/*
 Navicat Premium Data Transfer

 Source Server         : localmysql
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : localhost:3306
 Source Schema         : community

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 20/02/2024 10:37:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for lf_category
-- ----------------------------
DROP TABLE IF EXISTS `lf_category`;
CREATE TABLE `lf_category` (
  `cate_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `cate_name` varchar(50) NOT NULL COMMENT '分类名称',
  `is_top` int(1) DEFAULT '0' COMMENT '是否推荐(1推荐)',
  `cover_image` varchar(255) DEFAULT '' COMMENT '图片',
  PRIMARY KEY (`cate_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of lf_category
-- ----------------------------
BEGIN;
INSERT INTO `lf_category` VALUES (1, '校园', 0, 'http://pic.linfeng.tech/test/20220210/88148b0cd20f4ad4a09ce61866024281.jpg');
INSERT INTO `lf_category` VALUES (2, '音乐', 1, 'http://pic.linfeng.tech/test/20220207/8d796540337d4dd48ae11143fc570b77.jpg');
INSERT INTO `lf_category` VALUES (3, '生活', 1, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (4, '兴趣', 0, 'http://pic.linfeng.tech/test/20220210/c7d2e8489a5642ba91b7b5f97c282141.jpg');
INSERT INTO `lf_category` VALUES (5, '运动', 0, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (6, '旅行', 1, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (7, '知识', 0, 'http://pic.linfeng.tech/test/20220210/9621f4992cf64393be7567159b8d13f8.jpeg');
INSERT INTO `lf_category` VALUES (8, '动漫', 0, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (9, '情感', 0, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (10, '娱乐', 0, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (11, '宠物', 0, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (13, '美食', 0, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (14, '职场', 0, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (15, '摄影', 1, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (16, '时尚', 0, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (17, '阅读', 0, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (18, '游戏', 0, 'http://pic.linfeng.tech/test/20220207/69aaaff2132447dc9c4b893ce53e242d.jpg');
INSERT INTO `lf_category` VALUES (19, '打卡', 0, 'http://pic.linfeng.tech/test/20220207/2858506e3dca4a9a8367201ed04b80bb.png');
INSERT INTO `lf_category` VALUES (22, '开发', 0, 'http://pic.linfeng.tech/test/20220207/223ba0004cf54969a68a0ffad58cc51f.png');
INSERT INTO `lf_category` VALUES (23, '交流', 0, 'http://pic.linfeng.tech/test/20220207/e334ab448fb44083b3df5d288f18d261.jpg');
COMMIT;

-- ----------------------------
-- Table structure for lf_comment
-- ----------------------------
DROP TABLE IF EXISTS `lf_comment`;
CREATE TABLE `lf_comment` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pid` int(11) DEFAULT '0' COMMENT '父级id',
  `type` int(1) NOT NULL DEFAULT '1' COMMENT '评论类型:1帖子',
  `uid` bigint(20) NOT NULL DEFAULT '0' COMMENT '评论作者ID',
  `to_uid` int(11) DEFAULT '0' COMMENT '被回复用户ID',
  `post_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '评论帖子ID',
  `content` varchar(255) NOT NULL DEFAULT '' COMMENT '评论内容',
  `status` tinyint(4) DEFAULT '1' COMMENT '评论状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of lf_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for lf_comment_thumbs
-- ----------------------------
DROP TABLE IF EXISTS `lf_comment_thumbs`;
CREATE TABLE `lf_comment_thumbs` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `c_id` int(11) NOT NULL COMMENT '评论id',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of lf_comment_thumbs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for lf_follow
-- ----------------------------
DROP TABLE IF EXISTS `lf_follow`;
CREATE TABLE `lf_follow` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `follow_uid` int(11) NOT NULL COMMENT '关注的用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid` (`uid`,`follow_uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of lf_follow
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for lf_link
-- ----------------------------
DROP TABLE IF EXISTS `lf_link`;
CREATE TABLE `lf_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `title` varchar(100) NOT NULL COMMENT '标题',
  `url` varchar(255) NOT NULL COMMENT '路径',
  `img` varchar(255) NOT NULL COMMENT '图片',
  `type` int(1) DEFAULT '1' COMMENT '3圈子页轮播图',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of lf_link
-- ----------------------------
BEGIN;
INSERT INTO `lf_link` VALUES (47, '早安', '/pages/topic/detail?id=2', 'http://pic.linfeng.tech/test/20220418/9daf434efde346b29858c5b96fb280a2.jpeg', 3, '2022-01-26 14:03:38');
INSERT INTO `lf_link` VALUES (48, '晚安', '/pages/post/detail?id=140', 'http://pic.linfeng.tech/test/20220418/fd00e1b7f5d84f50b7f06e7c232624f1.jpeg', 3, '2022-01-26 14:03:38');
INSERT INTO `lf_link` VALUES (49, '你好', '/pages/post/detail?id=293', 'http://pic.linfeng.tech/test/20220719/c002d92851654755877cb1f3e7c9460d.jpeg', 3, '2022-07-19 20:49:39');
COMMIT;

-- ----------------------------
-- Table structure for lf_post
-- ----------------------------
DROP TABLE IF EXISTS `lf_post`;
CREATE TABLE `lf_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `topic_id` int(11) DEFAULT '0' COMMENT '圈子id',
  `discuss_id` int(11) DEFAULT '0' COMMENT '话题id',
  `vote_id` int(11) DEFAULT NULL COMMENT '投票id',
  `title` varchar(50) DEFAULT '' COMMENT '标题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '内容',
  `media` text COMMENT '文件',
  `read_count` int(255) DEFAULT '0' COMMENT '浏览量',
  `post_top` int(1) DEFAULT '0' COMMENT '置顶',
  `type` int(1) DEFAULT '1' COMMENT '帖子类型：1 图文 ，2视频 ，3文章，4投票',
  `address` varchar(255) DEFAULT NULL COMMENT '地址名称',
  `longitude` double(10,6) DEFAULT '0.000000' COMMENT '经度',
  `latitude` double(10,6) DEFAULT '0.000000' COMMENT '纬度',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '状态0正常1审核',
  `cut` int(1) NOT NULL DEFAULT '0' COMMENT '备用字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of lf_post
-- ----------------------------
BEGIN;
INSERT INTO `lf_post` VALUES (10, 3, 20, 0, NULL, '踩踩踩', '哈哈哈哈', '[\"http://pic.linfeng.tech/test/20220126/4515fc2cbed74d0b9163d35a12bd4c3b.png\"]', 0, 0, 1, '', 118.874190, 28.935920, '2022-01-26 22:08:02', 0, 0);
INSERT INTO `lf_post` VALUES (11, 3, 24, 0, NULL, '皮皮', '啊啊啊啊啊啊啊', '[\"http://pic.linfeng.tech/test/20220126/be7bcf13da1848c79c19ff01e7ce73e6.jpg\",\"http://pic.linfeng.tech/test/20220126/68530cbe2fab469d8e60f3aa2dd948e6.jpg\"]', 4, 0, 1, '', 118.874190, 28.935920, '2022-01-26 22:10:46', 0, 0);
INSERT INTO `lf_post` VALUES (12, 3, 19, 0, NULL, '哈哈哈', '噢噢噢噢', '[\"http://pic.linfeng.tech/test/20220127/01d66d7d8de4401c87e8ba3b475fc6fb.mp4\"]', 6, 0, 2, '', 118.872680, 28.936548, '2022-01-27 11:45:19', 0, 0);
INSERT INTO `lf_post` VALUES (14, 3, 24, 0, NULL, '翻唱老薛_高尚', '作曲翻唱cover by 薛之谦', '[\"http://pic.linfeng.tech/test/20220127/985fdbbb4cea47578eeb7be22f0c4854.mp4\"]', 6, 0, 2, '', 118.870078, 28.938044, '2022-01-27 12:26:28', 0, 0);
INSERT INTO `lf_post` VALUES (15, 4, 20, 0, NULL, '随风飘落', '细数门前落叶,倾听窗外雨声,涉水而过的声音此次响起,你被雨淋湿的心,是否依旧', '[\"http://pic.linfeng.tech/test/20220127/5d0ae07ed3ad40b4a5266c65096afd3c.mp4\"]', 6, 0, 2, '', 118.874190, 28.935920, '2022-01-27 15:40:23', 0, 0);
INSERT INTO `lf_post` VALUES (16, 4, 20, 0, NULL, '你在雨中行走,你从不打伞', '站在寒冬的冷风中,漫天的雪花正纷纷扬扬地包裹着这座寒冷的城市', '[\"http://pic.linfeng.tech/test/20220127/b4d45d81ace6482b94d8b3ae2e41918b.jpg\"]', 25, 1, 1, '', 0.000000, 0.000000, '2022-01-27 18:04:54', 0, 0);
INSERT INTO `lf_post` VALUES (17, 4, 20, 0, NULL, '嘿嘿', '你在等一场春华秋实，你在等新一轮的春暖花开，你在等从未有过的雷霆万...', '[\"http://pic.linfeng.tech/test/20220127/0e94cf332b034ee0be0a3a73ef76794f.mp4\"]', 28, 1, 2, '', 118.878741, 28.926487, '2022-01-27 18:08:59', 0, 0);
INSERT INTO `lf_post` VALUES (32, 3, 19, 2, NULL, '测试', '测试测试', '[]', 3, 0, 1, '', 0.000000, 0.000000, '2022-01-30 19:14:00', 0, 0);
INSERT INTO `lf_post` VALUES (33, 3, 20, 0, NULL, 'test', '哈哈哈哈哈', '[]', 4, 0, 1, '', 118.874190, 28.935920, '2022-02-10 14:29:34', 2, 3);
INSERT INTO `lf_post` VALUES (34, 6, 2, 0, NULL, '测试啦', '哈哈哈哈哈哈哈', '[\"http://pic.linfeng.tech/test/20220305/b59f6ecada1749538d1c9b79b7504a2e.png\",\"http://pic.linfeng.tech/test/20220305/a0128e656ff94aeb9e65a1c134748e1c.png\"]', 3, 0, 1, '', 0.000000, 0.000000, '2022-03-05 19:54:01', 0, 5);
INSERT INTO `lf_post` VALUES (35, 6, 2, 0, NULL, '翻唱', '翻唱系列薛之谦cover by 万豹', '[\"http://pic.linfeng.tech/test/20220305/9fb3ca2da5544dad97bc94b2613e4069.mp4\"]', 5, 0, 2, '', 0.000000, 0.000000, '2022-03-05 19:55:36', 0, 2);
INSERT INTO `lf_post` VALUES (39, 3, 2, 0, NULL, '123', '哈哈', '[\"http://pic.linfeng.tech/ti3WdmAbMXTd37ce1432eb02f2a60dd942914e5fdc3d.png\",\"http://pic.linfeng.tech/OxYTAkuGEQl8febb6ca7fa1cb0af1c54801a1201aaf5.png\",\"http://pic.linfeng.tech/a3iVEFAjvKfz14efa03d524a2a2483f7e759946a4f8d.png\",\"http://pic.linfeng.tech/PtwGdwH0olnVf1d827d196497177f016778dc2b53adb.png\"]', 9, 0, 1, '', 0.000000, 0.000000, '2022-10-01 16:33:23', 0, 0);
INSERT INTO `lf_post` VALUES (40, 4, 2, 1, NULL, '测试', '哦哦哦哦哦哦哦哦哦', '[]', 2, 0, 1, '', 0.000000, 0.000000, '2022-10-01 16:33:23', 0, 1);
INSERT INTO `lf_post` VALUES (41, 8, 2, 0, NULL, 'tttt', 'hhhhhhhh', '[]', 10001, 0, 1, '', 0.000000, 0.000000, '2022-10-01 16:33:23', 0, 1);
INSERT INTO `lf_post` VALUES (42, 8, 2, 0, NULL, '2222', 'hhhhh', '[\"http://pic.linfeng.tech/test/20220727/7756741ea0e24523a75187ce819b8bb6.jpg\"]', 1, 0, 1, '', 0.000000, 0.000000, '2022-10-01 16:47:35', 0, 4);
INSERT INTO `lf_post` VALUES (43, 13, 2, 0, NULL, '测试', '测试分类', '[]', 2, 0, 1, '', 0.000000, 0.000000, '2022-10-02 11:16:07', 0, 8);
INSERT INTO `lf_post` VALUES (44, 7, 2, 0, NULL, '1111112', '222', '[]', 1, 0, 1, '', 0.000000, 0.000000, '2022-10-20 15:44:23', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for lf_post_collection
-- ----------------------------
DROP TABLE IF EXISTS `lf_post_collection`;
CREATE TABLE `lf_post_collection` (
  `uid` int(11) NOT NULL COMMENT '用户id',
  `post_id` int(11) NOT NULL COMMENT '帖子id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of lf_post_collection
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for lf_post_fabulous
-- ----------------------------
DROP TABLE IF EXISTS `lf_post_fabulous`;
CREATE TABLE `lf_post_fabulous` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `post_id` int(11) NOT NULL COMMENT '帖子id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of lf_post_fabulous
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for lf_system
-- ----------------------------
DROP TABLE IF EXISTS `lf_system`;
CREATE TABLE `lf_system` (
  `config` varchar(50) NOT NULL,
  `value` text,
  `extend` text,
  `intro` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`config`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of lf_system
-- ----------------------------
BEGIN;
INSERT INTO `lf_system` VALUES ('miniapp', 'wx8068e9992da3e9d5', 'ba0b3020uio6bf078b8c0ada099e8ed', 'http://pic.linfeng.tech/test/20220724/9a665bf276a44827ad8ef0b3140a7d1d.png');
COMMIT;

-- ----------------------------
-- Table structure for lf_user
-- ----------------------------
DROP TABLE IF EXISTS `lf_user`;
CREATE TABLE `lf_user` (
  `uid` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `group_id` int(11) NOT NULL DEFAULT '2' COMMENT '用户组',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `gender` int(1) NOT NULL DEFAULT '0' COMMENT '性别(0未知，1男，2女)',
  `province` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '省份',
  `city` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '城市',
  `openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '小程序openid',
  `mp_openid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '公众号openid',
  `unionid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'unionid',
  `status` int(10) NOT NULL DEFAULT '0' COMMENT '状态',
  `intro` varchar(255) DEFAULT '这个人很懒，没留下什么' COMMENT '个性签名',
  `integral` int(255) DEFAULT '0' COMMENT '积分',
  `last_login_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最后登录ip',
  `tag_str` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '用户标签',
  `type` int(1) DEFAULT '0' COMMENT '0为普通用户，1官方账号2马甲虚拟用户',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of lf_user
-- ----------------------------
BEGIN;
INSERT INTO `lf_user` VALUES (1, '15678876545', 'piping', NULL, 2, 'http://pic.linfeng.tech/test/20220126/4515fc2cbed74d0b9163d35a12bd4c3b.png', 2, '浙江', '杭州', 'o7yfg4vyubvvxgjtaIuuuvcxcfGA', NULL, 'ajskajskajskajskasd', 1, '这个人很懒，没留下什么', 0, '39.130.106.136', '[\"萌新\",\"码农\",\"发帖达人\",\"运动\"]', 0, '2022-01-21 15:12:16', '2022-01-21 15:12:23');
INSERT INTO `lf_user` VALUES (2, NULL, 'kity', NULL, 2, 'http://pic.linfeng.tech/test/20220126/a58ae30c4bc44942afa4b9752bedc59b.jpeg', 1, '浙江', '宁波', 'o8cxg9vudddhsjjOK33TavcklbGA', NULL, NULL, 0, '这个人很懒，没留下什么', 0, '39.130.106.135', '[\"萌新\",\"码农\",\"发帖达人\",\"运动\"]', 0, '2022-01-21 15:12:26', '2022-01-21 15:12:28');
INSERT INTO `lf_user` VALUES (3, NULL, '天边的云', NULL, 2, 'https://thirdwx.qlogo.cn/mmopen/vi_32/jXkb3ugwib7xMoiaOpz03GLBDEsy9G6e7m0iaIpWoIt1UpTxCzibQA4M5dAicSjQBkOYA7Yu6jgrTKqmMiag9jtWl5Aw/132', 1, '', '浙江省杭州市 移通', 'o6z2m5Cc8jzhvANf42L5LQQRXsuu', NULL, NULL, 0, '这个人很懒', 0, '0:0:0:0:0:0:0:1', '[\"萌新\",\"圈子达人\",\"旅行\",\"软件开发\"]', 0, '2022-02-10 14:25:25', '2022-01-20 14:25:30');
INSERT INTO `lf_user` VALUES (4, NULL, '林风', NULL, 2, 'https://thirdwx.qlogo.cn/mmopen/vi_32/DicojWMHWdvIFD9tQa7XBt1iaTBQtYJ4icLE9z971WErrNXLLdFmPvACiaHpmibuCKicoTR8S1Z7iayXYynRwEFgVqlnw/132', 1, '', '浙江省宁波市 电信', 'o6z2m5DdnR0-9BdqZfK3Z3f_i4tt', NULL, NULL, 0, '这个人很懒，没留下什么', 0, '0:0:0:0:0:0:0:1', '[\"萌新\",\"码农\",\"发帖达人\",\"运动\"]', 1, '2022-04-15 12:37:39', '2022-01-27 14:21:58');
INSERT INTO `lf_user` VALUES (6, '15669210138', 'LF_968742', NULL, 2, 'http://pic.linfeng.tech/test/20220305/6c6b1a1f1a904d5bb155daa48d2a0649.jpg', 0, '', '浙江省宁波市 电信', NULL, NULL, NULL, 0, '这个人很懒，没留下什么', 0, '0:0:0:0:0:0:0:1', '[\"萌新\"]', 1, '2022-03-05 19:45:08', '2022-03-05 19:42:28');
INSERT INTO `lf_user` VALUES (7, '15105701666', 'LF_353869', NULL, 2, 'http://pic.linfeng.tech/test/20220126/4515fc2cbed74d0b9163d35a12bd4c3b.png', 0, '', '浙江省宁波市 电信', NULL, NULL, NULL, 0, '这个人很懒，没留下什么', 0, '0:0:0:0:0:0:0:1', '[\"萌新\"]', 0, '2022-04-03 14:20:01', '2022-04-03 14:18:40');
INSERT INTO `lf_user` VALUES (8, '13245677090', 'LF_79271821', NULL, 2, 'http://pic.linfeng.tech/test/20220126/4515fc2cbed74d0b9163d35a12bd4c3b.png', 0, '', '', NULL, NULL, NULL, 0, '这个人很懒，没留下什么', 0, NULL, '[\"新人\"]', 0, '2022-07-27 16:33:05', '2022-07-27 16:33:05');
INSERT INTO `lf_user` VALUES (12, NULL, '天边的云', NULL, 2, 'https://thirdwx.qlogo.cn/mmopen/vi_32/jXkb3ugwib7xMoiaOpz03GLBDEsy9G6e7m0iaIpWoIt1UpTxCzibQA4M5dAicSjQBkOYA7Yu6jgrTKqmMiag9jtWl5Aw/132', 0, '', '', 'o6z2m5Cc8jzhvANf42L5LQQRXsuY', NULL, NULL, 0, '这个人很懒，没留下什么', 0, NULL, '[\"新人\"]', 0, '2022-08-18 11:03:36', '2022-08-18 11:03:36');
INSERT INTO `lf_user` VALUES (13, '15890909999', 'LF_74950175', NULL, 2, 'http://pic.linfeng.tech/test/20220126/4515fc2cbed74d0b9163d35a12bd4c3b.png', 0, '', '', NULL, NULL, NULL, 0, '这个人很懒，没留下什么', 0, NULL, '[\"新人\"]', 0, '2022-09-04 10:48:54', '2022-09-04 10:48:54');
INSERT INTO `lf_user` VALUES (14, '17890909898', 'LF_55258784', NULL, 2, 'http://pic.linfeng.tech/test/20220126/4515fc2cbed74d0b9163d35a12bd4c3b.png', 0, '', '', NULL, NULL, NULL, 0, '这个人很懒，没留下什么', 0, NULL, '[\"新人\"]', 0, '2022-10-08 13:41:03', '2022-10-08 13:41:03');
INSERT INTO `lf_user` VALUES (18, '18691876612', 'LF_wx68215506', NULL, 2, 'http://pic.linfeng.tech/test/20220126/4515fc2cbed74d0b9163d35a12bd4c3b.png', 0, '', '', 'oB2sm4ylkCQSL6ESOvZR6UIGzr0Y', NULL, NULL, 0, '这个人很懒，没留下什么', 0, NULL, '[\"新人\"]', 0, '2024-02-06 12:07:54', '2024-02-06 12:07:54');
COMMIT;

-- ----------------------------
-- Table structure for lf_user_topic
-- ----------------------------
DROP TABLE IF EXISTS `lf_user_topic`;
CREATE TABLE `lf_user_topic` (
  `uid` int(11) NOT NULL COMMENT '用户id',
  `topic_id` int(11) NOT NULL COMMENT '圈子id',
  `create_time` datetime DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  UNIQUE KEY `uid` (`uid`,`topic_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of lf_user_topic
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_cron_triggers` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_job_details` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', NULL, 'io.linfeng.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xEFBFBDEFBFBD0005737200156F72672E71756172747A2E4A6F62446174614D6170EFBFBDEFBFBDEFBFBDE8BFA9EFBFBDEFBFBD020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D6170EFBFBD08EFBFBDEFBFBDEFBFBDEFBFBD5D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013EFBFBD2EEFBFBD28760AEFBFBD0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507EFBFBDEFBFBDEFBFBD1660EFBFBD03000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002F696F2E6C696E66656E672E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686AEFBFBD014B597419030000787077080000017E28EFBFBD64EFBFBD7874000E3020302F3330202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673BEFBFBDEFBFBDCC8F23EFBFBD0200014A000576616C7565787200106A6176612E6C616E672E4E756D626572EFBFBDEFBFBDEFBFBD1D0BEFBFBDEFBFBDEFBFBD0200007870000000000000000174000672656E72656E74000CE58F82E695B0E6B58BE8AF95737200116A6176612E6C616E672E496E746567657212E2A0A4EFBFBDEFBFBDEFBFBD3802000149000576616C75657871007E0013000000007800);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_scheduler_state` VALUES ('ProjectScheduler', 'jinweizhedeMacBook-Pro.local1708331659793', 1708331932015, 15000);
INSERT INTO `qrtz_scheduler_state` VALUES ('RenrenScheduler', 'LAPTOP-47M7VFTC1641368553138', 1641368599756, 15000);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_triggers` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', 'TASK_1', 'DEFAULT', NULL, 1641369600000, -1, 5, 'WAITING', 'CRON', 1641368553000, 0, NULL, 2, '');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint(4) DEFAULT NULL COMMENT '任务状态  0：正常  1：暂停',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='定时任务';

-- ----------------------------
-- Records of schedule_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `job_id` bigint(20) NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `status` tinyint(4) NOT NULL COMMENT '任务状态    0：成功    1：失败',
  `error` varchar(2000) DEFAULT NULL COMMENT '失败信息',
  `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`),
  KEY `job_id` (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='定时任务日志';

-- ----------------------------
-- Records of schedule_job_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_captcha
-- ----------------------------
DROP TABLE IF EXISTS `sys_captcha`;
CREATE TABLE `sys_captcha` (
  `uuid` char(36) NOT NULL COMMENT 'uuid',
  `code` varchar(6) NOT NULL COMMENT '验证码',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统验证码';

-- ----------------------------
-- Records of sys_captcha
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `param_key` varchar(50) DEFAULT NULL COMMENT 'key',
  `param_value` varchar(2000) DEFAULT NULL COMMENT 'value',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态   0：隐藏   1：显示',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `param_key` (`param_key`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统配置信息表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1, 'CLOUD_STORAGE_CONFIG_KEY', '{\"type\":2,\"qiniuDomain\":\"http://pic.linfeng.tech\",\"qiniuPrefix\":\"test\",\"qiniuAccessKey\":\"Fmp__H-4gMbT5nu-FSW7OzFKfFCAFPPkNO0CB\",\"qiniuSecretKey\":\"YVBVbxI_XXWlax5gXwwwzcFuIiNvqdeQNfb\",\"qiniuBucketName\":\"linfeng01\",\"aliyunDomain\":\"https://multishop.oss-cn-shenzhen.aliyuncs.com/\",\"aliyunPrefix\":\"\",\"aliyunEndPoint\":\"https://oss-cn-shenzhen.aliyuncs.com/\",\"aliyunAccessKeyId\":\"LTAIbbbbbbYgE0fyPX0iuX\",\"aliyunAccessKeySecret\":\"SH1ZOzzXH0DEWIg0gqyJ2oooYI5\",\"aliyunBucketName\":\"multshop\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qcloudBucketName\":\"\"}', 0, '云存储配置信息');
INSERT INTO `sys_config` VALUES (2, 'user', 'zhangsan', 1, 'test11');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) DEFAULT NULL COMMENT '请求参数',
  `time` bigint(20) NOT NULL COMMENT '执行时长(毫秒)',
  `ip` varchar(64) DEFAULT NULL COMMENT 'IP地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, 0, '系统管理', NULL, NULL, 0, 'system', 0);
INSERT INTO `sys_menu` VALUES (2, 1, '管理员列表', 'sys/user', NULL, 1, 'admin', 1);
INSERT INTO `sys_menu` VALUES (3, 1, '角色管理', 'sys/role', NULL, 1, 'role', 2);
INSERT INTO `sys_menu` VALUES (4, 1, '菜单管理', 'sys/menu', NULL, 1, 'menu', 3);
INSERT INTO `sys_menu` VALUES (5, 1, 'SQL监控', 'http://localhost:8080/druid/sql.html', NULL, 1, 'sql', 4);
INSERT INTO `sys_menu` VALUES (6, 1, '定时任务', 'job/schedule', NULL, 1, 'job', 5);
INSERT INTO `sys_menu` VALUES (7, 6, '查看', NULL, 'sys:schedule:list,sys:schedule:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (8, 6, '新增', NULL, 'sys:schedule:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (9, 6, '修改', NULL, 'sys:schedule:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (10, 6, '删除', NULL, 'sys:schedule:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (11, 6, '暂停', NULL, 'sys:schedule:pause', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (12, 6, '恢复', NULL, 'sys:schedule:resume', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (13, 6, '立即执行', NULL, 'sys:schedule:run', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (14, 6, '日志列表', NULL, 'sys:schedule:log', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:list', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:list', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (27, 1, '参数管理', 'sys/config', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'config', 6);
INSERT INTO `sys_menu` VALUES (29, 1, '系统日志', 'sys/log', 'sys:log:list', 1, 'log', 7);
INSERT INTO `sys_menu` VALUES (30, 42, '文件上传', 'oss/oss', 'sys:oss:all', 1, 'oss', 6);
INSERT INTO `sys_menu` VALUES (36, 0, '动态管理', '', '', 0, 'geren', 3);
INSERT INTO `sys_menu` VALUES (37, 42, '应用配置管理', 'admin/system', NULL, 1, 'config', 6);
INSERT INTO `sys_menu` VALUES (38, 37, '查看', NULL, 'admin:system:list,admin:system:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (39, 37, '新增', NULL, 'admin:system:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (40, 37, '修改', NULL, 'admin:system:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (41, 37, '删除', NULL, 'admin:system:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (42, 0, '应用管理', '', '', 0, 'zhedie', 2);
INSERT INTO `sys_menu` VALUES (43, 88, '会员管理', 'admin/user', NULL, 1, 'geren', 6);
INSERT INTO `sys_menu` VALUES (44, 43, '查看', NULL, 'admin:user:list,admin:user:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (45, 43, '新增', NULL, 'admin:user:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (46, 43, '修改', NULL, 'admin:user:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (47, 43, '删除', NULL, 'admin:user:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (48, 89, '分类管理', 'admin/category', NULL, 1, 'zhedie', 6);
INSERT INTO `sys_menu` VALUES (49, 48, '查看', NULL, 'admin:category:list,admin:category:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (50, 48, '新增', NULL, 'admin:category:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (51, 48, '修改', NULL, 'admin:category:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (58, 36, '帖子管理', 'admin/post', NULL, 1, 'config', 6);
INSERT INTO `sys_menu` VALUES (59, 58, '查看', NULL, 'admin:post:list,admin:post:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (60, 58, '新增', NULL, 'admin:post:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (61, 58, '修改', NULL, 'admin:post:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (62, 58, '删除', NULL, 'admin:post:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (68, 36, '评论管理', 'admin/comment', NULL, 1, 'config', 6);
INSERT INTO `sys_menu` VALUES (69, 68, '查看', NULL, 'admin:comment:list,admin:comment:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (70, 68, '新增', NULL, 'admin:comment:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (71, 68, '修改', NULL, 'admin:comment:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (72, 68, '删除', NULL, 'admin:comment:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (78, 42, '轮播图管理', 'admin/link', NULL, 1, 'config', 6);
INSERT INTO `sys_menu` VALUES (79, 78, '查看', NULL, 'admin:link:list,admin:link:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (80, 78, '新增', NULL, 'admin:link:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (81, 78, '修改', NULL, 'admin:link:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (82, 78, '删除', NULL, 'admin:link:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (88, 0, '用户管理', '', '', 0, 'admin', 6);
INSERT INTO `sys_menu` VALUES (89, 0, '内容管理', '', '', 0, 'editor', 9);
COMMIT;

-- ----------------------------
-- Table structure for sys_oss
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(200) DEFAULT NULL COMMENT 'URL地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='文件上传';

-- ----------------------------
-- Records of sys_oss
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '运营', '运营人员', 1, '2022-01-05 13:35:45');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色与菜单对应关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) DEFAULT NULL COMMENT '盐',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `UNION_ID` varchar(36) DEFAULT NULL COMMENT '微信用户统一标识',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', 'cdac762d0ba79875489f6a8b430fa8b5dfe0cdd81da38b80f02f33328af7fd4a', 'YzcmCZNvbXocrsz9dm8e', 'root@163.com', '18100900090', 1, 1, '2022-01-05 13:36:24', NULL);
INSERT INTO `sys_user` VALUES (2, 'yunying', '5ad9030f5f5e49ed06e6dfb44f0da6f9a95cf9f68276207c1277c05d31bc5fc6', 'hXie4Fbhak1N6pNOtIoo', 'yunying@163.com', '15669231234', 1, 1, '2022-01-05 13:36:24', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户与角色对应关系';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (1, 2, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_token
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token` (
  `user_id` bigint(20) NOT NULL,
  `token` varchar(100) NOT NULL COMMENT 'token',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统用户Token';

-- ----------------------------
-- Records of sys_user_token
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_token` VALUES (1, 'bae623cdee585dc9db254b8385488e1b', '2022-10-21 03:48:44', '2022-10-20 15:48:44');
INSERT INTO `sys_user_token` VALUES (2, '354a481dc6c46c194bc1d01aa7f4bbeb', '2022-01-06 02:55:50', '2022-01-05 14:55:50');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
